package com.example.rfidserver.db;

import android.provider.BaseColumns;

import com.example.rfidserver.R;
import com.example.rfidserver.pojo.Consume;

public class RfidSystemDBContract {
    //该类的名字就是数据库的名字
    //不让程序员创建该类的对象
    private RfidSystemDBContract(){};



    //user表
    public static abstract class User implements BaseColumns {
        //表名
        public static final String TABLE_NAME = "user";
        //表的列名
        public static final String COLUMN_NAME_ID = "id";
        public static final String COLUMN_NAME_R_ID = "r_id";
        public static final String COLUMN_NAME_TICKET_ID = "ticket_id";
        public static final String COLUMN_NAME_INTERGRAL_BILL = "integral_bill";
        public static final String COLUMN_NAME_ROLL = "roll";
        public static final String COLUMN_NAME_CONSUME_ID = "consume_Id";
    }

    //ticket表
    public static abstract class Ticket implements BaseColumns{
        //表名
        public static final String TABLE_NAME = "ticket";
        //表的列名
        public static final String COLUMN_NAME_TICKET_ID = "ticket_id";
        public static final String COLUMN_NAME_TICKET_TYPE = "ticket_type";
        public static final String COLUMN_NAME_TICKET_DESCRIPTION = "ticket_description";
    }


    //consume表
    public static abstract class Consume implements BaseColumns{
        //表名
        public static final String TABLE_NAME = "consume";
        //表的列名
        public static final String COLUMN_NAME_CONSUME_ID = "consume_Id";
        public static final String COLUMN_NAME_CONSUME_ITEM_NAME = "consume_Item_name";
        public static final String COLUMN_NAME_CONSUME_ITEM_INTEGRAL = "consume_Item_integral";
    }




}
